﻿    /***************************************************************************************************
    **  Table:	    public.role
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered role.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.role (name) VALUES ('application administrator');
    INSERT INTO public.role (name) VALUES ('application developer');
    INSERT INTO public.role (name) VALUES ('application tester');
    INSERT INTO public.role (name) VALUES ('user');

	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.role;